Order by index number in SQL

SELECT empid, lastname FROM HR.Employees
ORDER BY 1 DESC --order by first column

SELECT empid, lastname FROM HR.Employees
ORDER BY 2 DESC --order by second column