Número X de un total de Y

[huesos52]

Código mysql:

mysql> desc order_m;
+-------+-------+------+-----+---------+-------+
| Field | Type  | Null | Key | Default | Extra |
+-------+-------+------+-----+---------+-------+
| nom   | text  | YES  |     | NULL    |       |
| valor | float | YES  |     | NULL    |       |
+-------+-------+------+-----+---------+-------+
2 rows in set (0.02 sec)
 
mysql> SELECT
    ->     (@REG := @REG + 1) Linea,
    ->     nom,
    ->     valor
    -> FROM
    ->     (SELECT
    ->         @REG :=0,
    ->         nom,
    ->         valor
    ->     FROM order_m) om order by om.valor desc;
+-------+-------+-------+
| Linea | nom   | valor |
+-------+-------+-------+
|     1 | maria |    43 |
|     2 | ana   |    24 |
|     3 | juan  |    20 |
|     4 | pepe  |    14 |
|     5 | santi |     3 |
+-------+-------+-------+
5 rows in set (0.02 sec)
 
mysql>
 

algo así?