Hey,
You can use COUNT function.
select count(*) from your_table
Get the count of the record in the table and add 1 to it.
But, this will work fine only if you are not deleting the records physically from the table otherwise it will work in any condition.
Hope this helps you.
Regards,
Lok..