How to find out the position of a user in a table by a certain field and sorting?

Question

MySQL

There is a table with users.
The table has a field of type int - balance.
Is it possible to immediately return the position in the balance field with the direction desc?

Answer 1

SELECT COUNT(*) + 1 AS `position`
  FROM `users`
  WHERE `balance` > (
    SELECT `balance`
      FROM `users`
      WHERE id = :userId
  )