HHH-6914: Fix queries with ORDER BY over same column

Fix queries with ORDER BY over same column referenced under 2 different names on SQL Server.

Change in short: always use ROW_NUMBER OVER in SQL Server to guard against "SQLServerException: A column has been specified more than once in the order by list. Columns in the order by list must be unique".
This basically rolls back HHH-7370, so I removed the test case for that issue (it was failing, of course).