It seems that this is a known bug but I only noticed it yesterday.
Imagine you have a field named price and it’s type is VARCHAR (it doesn’t matter why it’s not INT or FLOAT) and you want to use ORDER BY clause so you can list table rows ordered by price value.
It won’t work, since the prices will be listed alphabetically, you may read here how to fix this issue.