How to store the number of issued IDs?

Question

Database

I define the user id in numerical sequence, i.e. 1,2,3, etc. I'm interested in how to store the value of the last issued id, in order to know what number to assign for a new id? I came up with an option with a table in the database that has a users_id_count column, and it stores the number of issued ids, and if you need to create a new id, then I just get the value of this field and plus 1. Is this option normal or are there more beautiful solutions?
Ps I need it to work with sharding