What is the difference between below queries?
Select * from table_name order by primary_key_id desc;
Select * from table_name order by 1 desc;

Answer:

Both will return the same result by applying descending order.
Generally we give Id as a primary key field which is by-default numeric value and 1 is also numeric value.That is the reason we get same record with bot the queries.