How to sort data from the database again from 1 to 10

How to sort data from the database from 1 to 10 again $ query & nbsp ;=& nbsp; "select & nbsp; * & nbsp; from & nbsp; software & nbsp; order & nbsp; by & nbsp; cnet_total_download

$query = "select * from software order by cnet_total_downloads limit 10";
$result = mysql_query($query) OR die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo "X.".$row['software_name'];
}

The expected result is how the above X is changed to 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.

Final Display
1.
2. B
3. c
.
.
.
10. Z

How can I achieve this in 1 to 10: More