On the left is the DNS server that DHCP sets first. On the right is one it sets second.

This is a mixed machine network (Windows, MacOS, iOS, Android etc).

My clients will mostly pick option number one, but as you can see it's not a guarantee at all.