> Generally in MySQL we send queries massaged to a point where optimizer doesn’t have to think about anything.

https://dom.as/2015/07/30/on-order-by-optimization/ - Wisdom from the guy who managed to get MySQL to work at facebook scale.