Some scores are not sorted correctly in leaderboards

[AmnezziaCS]

Description

Following the unban of a friend of mine, him and I have noticed that some of his scores were sorted weirdly on the website (lazer and classic mode, in-game leaderboards are not affected by this). The issue being that some of his scores are not placed at the correct leaderboard spot. On every example shown here, the maps were played with 4 mods and have no spinners meaning the first SS rank should be the #1.

Some examples of maps where this happens (note that there are a lot more):

• https://osu.ppy.sh/beatmapsets/1827765#osu/3818042
• https://osu.ppy.sh/beatmapsets/1900674#osu/3998229
• https://osu.ppy.sh/beatmapsets/1928041#osu/3981780

Investigations

On every one of the maps I have linked. He was the first one to submit and this actually shows when looking at the score times (using this map as an example):


We can clearly see that the first submitted score was MystExi's one.

It seems to me that the issue comes from the scores IDs being reprocessed while he was banned. If we take a look at the scores I've just shown the dates of:

• https://osu.ppy.sh/scores/1688279698 (ImMyyrh's score)
• https://osu.ppy.sh/scores/1688279719 (MystExi's score)

1688279698 < 1688279719 # but it should be the opposite...

MystExi's score should in theory have a lower id since he was the first one to submit yet it's not the case here.

[cl8n]

seems similar to #11553

[peppy]

Same issue, duplicate. Will continue tracking at #11553.