Automatic Numbered Row

I am trying to build a Que system and need a numerical row that can be changed if I ned to bump a person before someone else. I want to be able to have a person become number one when someone else’s row is deleted. So I can later automate a text letting them know its their turn. How do I do that please?