Odd-Total ID Swap Logic

If the total amount is an odd number, how would you swap the id for each two consecutive records and leave the last one unswapped?

Use the records table and return one row per record. Preserve the original row count, and if there is an unpaired final record, keep its id unchanged.

Output

1. id as the swapped id value for each row
2. value as the original row value
3. Return rows ordered by the original record sequence