How is ORDER BY logically Processed
Think of the way telephone directories are (typically) ordered.

If they were generated by an SQL query it would be

ORDER BY LastName ASC,
         FirstName ASC


The names are ordered by LastName first. 

The secondary column is only used for ordering within groups of people sharing the same last name.