• Thanks Luis , sorry for the confusion.

    As you all suggested we can go with identity columns as a primary key and computed column for unique sequence numbers.