Running a query with Order By in the Text window does not produce correctly sorted results in the Data window if the columns for the table were already manually sorted from inside the Data window.

Selecting "clear all sorting" in the Data window of a table before running the query fixes the sorting issue.

The order by condition of a query in the Text window should take precedence over any manual table sorting that may have occurred at some point in the past.