In MySQL is it possible to auto increment in pairs?

I have match_id which always comes in pairs. Instead of incrementing as follows:

1,2,3,4...

Is it possible to increment like this:

1,1,2,2,3,3,4,4

If not how can I guarantee that I will always have at most two identical match_id. I've tried to implement a Manual solution in code but occasionally I get three at a time if there is a collision.

This is not a primary ke开发者_StackOverflowy. However I want the match_id to come in pairs so that if I look up match 56, it will show the following:

match_id, user_id, score
56, 29, 434
56, 49, 516

Dividing by two is a possible solution although it makes the queries really messy. For example searching for match 56 becomes really convoluted

I'm pretty sure that you cannot autoincrement in pairs like that. However, you can easily treat a column that has 1,2,3,4,... as if it had 1,1,2,2,3,3,4,4,... by using FLOOR((match_id+1)/2) instead of match_id. You can either use that expression in your data retrieval statements or else denormalize your data base and define a column where you insert that value along with the autoincrement value.