Your DAC chip has a maximum sample rate specification (check datasheet). If you overclock it, it will probably behave the same as any other digital circuit under such circumstances. In order of increasing clock frequency, it will probably work fine a bit above its spec (but with no guarantee), then begin missing some bits once in a while as the slowest path inside the chip gets overwhelmed, then miss some bits more often, then output complete garbage. It depends on temperature, supply voltage, etc, so just because "it seems to work today", doesn't mean you can count on it.
Note the internal clock of the DDS generator may run higher than the DAC sample rate. That depends how it is implemented. For example you may be able to use less FPGA gates by using a DDS that needs several clocks to output a sample instead of one, so it can use only one multiplier instead of several in parallel. Then you have two clocks, a faster one for the core that computes the sample, and a slower one for the actual DAC sample rate.
How fast your DAC should be really depends on how clean you want your output 6MHz sinewave to be. Fs=20MHz sample rate for a F=6MHz sine wave is 3.33 samples per period, which is really low. In the time domain, the output will not look much like a sine wave. In the frequency domain, there will be substantial aliasing products at nFs-F and nFs+F. This means you will either need an annoyingly complicated analog filter to get a usable sine wave, or an application that doesn't care about the aliasing products. In fact, with only 3.33 samples per period, it would probably be simpler to just get rid of the DAC, output a square wave, and filter it, but then you lose the fine frequency adjustment that DDS offers.
If your application needs a cleaner sine wave, then... you need a DAC with higher sampling rate, or a DDS chip, whatever is cheaper. Remember the total cost includes analog output filter, so a faster more expensive DAC may end up cheaper if you can replace a complicated filter with a simple one.