Comment by defaultcompany

It’s not really mirrored (assuming you meant reversed). Here’s a page describing the two orders in relation to each other from a wiki I wrote:

https://github.com/weinberg/SQLToy/wiki/Two-Key-Concepts