Interestingly, although using Select TOP 100 PERCENT with an ORDER BY clause results in the sort order being ignored, specifying Select TOP 99.999999 PERCENT will honour the ORDER BY.

I'm not for one minute advocating this as a safe solution, just that it seems like inconsistent behaviour.