How to generate auto number?

Question

Hi!
Could you please help me how to generate auto incrementing number ? For ex. when i add new record in the database, before inserting data it should show number say member id 101.  when i want to add next record it should show consecutive number say 102.  I would appreciate your help.

Thanks!