Answer 1

When using ORDER BY with several columns, the second column only matters when the rows have the same value for the first column, the third column only matters when the rows have the same value for the first two columns, etc.

So no conflict there.