Count of Published Posts

I am using the Classic Theme and would like to have the post # of each post displayed – not the ID# – the ID# seems to be incremented for each revision and so is not the true published post #. I can create a published_post_num column in wp_posts – but how/where to increment it after each new post is published?

Any help appreciated!