Problem with my loop

I have a loop that I use to insert multiple row in a database. The problem I have is insert the record in a weird way. For instance I want to insert 10 records at the same time, but this is how it insert it
1
1
2
1
2
3
1
2
3
4
etc.
I want it to be inserted in this way.
1
2
3
4
5
6
7
8
9
10
Can someone help how to do that?
...