Incrementing values when values changes in different column in excel

i want to change values when id values changes to different in excel https://i.stack.imgur.com/t8Rod.png

Any help will be thankfull.