how to make a value in sql increment when insterting code example

Example: increment integer in table sql

UPDATE myTable
SET ID = ID + 1