Inserting sequence numbers in Sqlite Database

How can one insert a new column (Integer) into an existing Sqlite3 DB that contains sequential (unique, positive) numbers starting from 0 (max value = number of rows).