How to add a column to existing table which contain ids in serial order from 1 to number of rows?

I have already created a mysql table. I want to add a column (say ID) to the table and assign ID column values from 1 to number of rows in the table. How would I achieve that?