-- Step 1: Create the table
CREATE TABLE IF NOT EXISTS seat (
    id INTEGER PRIMARY KEY,
    student TEXT NOT NULL
);

-- Step 2: Insert sample data
DELETE FROM seat;  -- Clear existing data

INSERT INTO seat (id, student)
VALUES 
(1, 'Alice'),
(2, 'Bob'),
(3, 'Charlie'),
(4, 'David');

SELECT ROW_NUMBER() OVER() id, student
FROM seat
ORDER BY IF(MOD(id, 2) = 0, id-1, id+1)

SELECT * FROM seat;
by