What order by clause does?
It helps to sort the results of queries. It specifies the data in an operating order along with data sorting options in ascending (ASC) or descending (DESC) order. By default, it provides ascending order on the mission of order placements. ORDER BY clauses contains a wide range of statements such as DELETE and UPDATE. ORDER BY clauses works on final result of a table that is why they come at the end of a statement instead of in a subquery or earlier function set.