I have a table with a primary key column ID, which needs to sequentially increase when a new record is inserted into the DB. (ie: 1,2,3,...)

Is there an option for the DB that I can set to do that automatically?

If not then what is the syntax to do it manually?