How can I create a column with a sequence for every new id

[glorinthegalaxy]

I need to create a column that counts sequentially an ID column and re-starts the counting every time the column has a new ID. Something as shown in the image, do you know if there is a way to do that?