experts, Thanks for your feedback.
Actually, I am trying to develop DML for cashier with drivers shipment cash entry. Each day driver might have multiple shipments i mean delivery loads. Let say driver maria is having 3 shipments for a day . So when first time maria data inserted in to table then its should auto insert with value (1)and then same driver maria data inserted second time then its should auto insert with value (2) and same driver maria data inserted  third time then its should auto insert with value (3.) 
Here key identifier for auto insert is name.
And this will keep rotating  everyday since same driver will have shipment every day. I mean sunday might have 1 shipment and monday might have 2 shipment its goes on.

I am using .Net framework for the same but meanwhile trying to see if anything can be done via SQL too.

A