I had a feeling that was the case thanks I just have never seen SQL not return the order correctly when it has a clustered index.

No one would be able to change the index or tinker it and the table is dropped and rebuild every night so there would be no issue with the stats but I will have to use the order by to be sure.

The issue was the tbale could potentially be 10s of millions of rows and speed could be an issue here.