Is there any way to find out the number of an article?

Well, no that’s exactly what I can unfortunately not use because of what I described above 😉
See, let’s say I have 2 posts, but each post was edited 3 times, now in the DB it looks like this:

ID | post_title | post_status
—————————–
1 | bla | publish
2 | bla | refurbish
3 | bla | refurbish
4 | lorem | publish
5 | lorem| refurbish
6 | lorem| refurbish

You see, my two posts have the IDs 1 and 4 because of those backups hat use the same IDs, while i would need them to have he IDs 1 and 2.

Unfortunately it doesn’t work as hoped.
There is no output from the function.

I put this into my fuctions.php in my theme

function updateNumbers() {
    global $wpdb;
    $querystr = "SELECT $wpdb->posts.* FROM $wpdb->posts WHERE $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_type = 'post' ";
    $pageposts = $wpdb->get_results($querystr, OBJECT);
    $counts = 0 ;
    if ($pageposts):
    foreach ($pageposts as $post):
    setup_postdata($post);
    $counts++;
    add_post_meta($post->ID, 'incr_number', $counts, true);
    update_post_meta($post->ID, 'incr_number', $counts);
    endforeach;
    endif;
    }
    add_action ( 'publish_post', 'updateNumbers' );
    add_action ( 'deleted_post', 'updateNumbers' );
    add_action ( 'edit_post', 'updateNumbers' );
]

And this is my code for displaying the post:

<?php
global $post;
$myposts = get_posts('numberposts=1&offset=0&category=3');
foreach($myposts as $post) : setup_postdata($post);?>
//then some output like the_content()...
//and herer the call to get the number: but this doesn's show anything:
<?php echo get_post_meta($post->ID,'incr_number',true); ?>
<?php endforeach; ?>