I'm a developer myself and noticed a classic issue. The scores are sorted as text and not by numbers. Therefore, 200 is > 1000. To get things to sort correctly, you should cast the number before sorting.
MySQL Cast Example:
ORDER BY
CAST(score AS INT)
However, a better alternative is to store the number as an integer. Then, a cast is not required, storage space is reduced, and performance increases.
