How to swap the values of two rows in a table

What is the purpose of the query? it seems more that the data is incorrect and you wish to update it?