Here is a very simple way to achieve what you are looking for.

SELECT TOP 1 empid,empWage

FROM

(

SELECT TOP 4 empid,empWage

FROM Empdetails

ORDER BY empid DESC

) a

ORDER BY a.empid ASC