Fce problem in SQL Upadte Command in CORE PHP

Sir, in Product table we use Auto Increment in prod_id field. In this video you show how to delete row and you delete the row having product ID 104. Then why remaining row (105 & 106) cannot update as 105 to 104 and 106 to 105?

Please again watch the videos and check your query.