Help with auto increment

Could someone explain to me how to assign and int field to auto increment
whenever a new entry is placed in the database? oid doesn't work because
it's not sequential.

Thanks for the help