Is there a simple way to add a column to an existing table & populate it with consecutive numbers ?

I have a table which I want to add a new column to, and populate on each row a consecutive number - eg 1,2,3,4,5,6


thanks !