In MySQL, how can I print the position of a record in the selected result set?

In MySQL, we sometimes want to select N records and add a column in each record in the results to mark the number of records.
In Oracle, rownum can be used for simple implementation. But in MySQL, how can this problem be implemented? The following is an example:
Select t. page, t. pv, @ rn: = if (1 = 1, @ rn + 1, @ rn) as rn
From
(Select
Page,
Pv
From
Module_page_statis
Where
StatisDay = '2017-05-31 'and module = 'new _ info' order by 2 desc limit 10) t, (select @ rn: = 0) t2
Order by t. pv desc

Here is a slight explanation:
1, (select @ rn: = 0) only serves as initialization.
2, @ rn: = if (1 = 1, @ rn + 1, @ rn). This statement is executed once every record is selected. Of course, more complex logic can be added here.