• Agree with NPeeters

    , sounds like an identity column will do the job.