Contiguous Order Shifting

A recurring ordering-integer problem where inserts/deletes at position N require transactional updates that shift all rows at or after N to keep questionOrder contiguous and free of gaps, duplicates, or misordered results.