The results are correct, as the value of the RateUp is the same, so there is no guarantee which of those 2 rows will be the first and which is the second in the results.

MySQL innodb_version 5.7.12 or innodb_version 5.7.24 are correct, not MariaDB
you tell that their db is wrong and yours is right? is that correct?
And by your words ASC is correct and DESC is correct, but they are different. DO you understand what shi...s you are saying?

"If multiple rows have identical values in the ORDER BY columns, the server is free to return those rows in any order, and may do so differently depending on the overall execution plan. In other words, the sort order of those rows is nondeterministic with respect to the nonordered columns." https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html

In MySQL ASC and DESC work as expected.
Here only ASC works, but DESC can return random value which is other word of UNTRUSTED operation in critical situations (including security scenarious)!
=>So if you want your db to be used by serious players, you MUST clean all possibilities of random returning of values (at least).
I am sorry if you can't understand that basic rule.
And I am sorry that you can't see this as bug.
Good luck