One approach for a single query would be to utilize a temporary table.
Use this at your own discretion and create a backup to ensure nothing bad happens. If you already have a table named temp_table, choose a new naming schema.
For one item at a time and a bit more manual control:
Code:
create temporary table temp_table
as
select * from items where id = '1377';
update temp_table set id = '90525' where id = '1377';
insert into items select * from temp_table;
drop temporary table temp_table;
-creates temp table
-inserts a new row in temp table of the specified item from items
-updates the id of the item in the temp table
-inserts the edited row into items table
-drops the temp table