Displaying numbers with results - any ideas?

[Daniel Crompton]

Any ideas how to get sequential numbers to display with results?.

SELECT * FROM musicchart WHERE artistcountry = ''uk''

I need to get the result to show with numbers down the left side such as:

1 mark
2 john
3 pete
4 mike
5 tom

i.e. if it pulls back 3 results show as

1 john
2 mike
3 tom


I can't seem to work out a way to automatically display numbers ' 1 to whatever '  
with the results.

Any ideas?