Make another column in a table equal to the primary key column
I explained the error message in an earlier post 4.5 years ago (Problem with MySQL subquery)
SUGGESITON : Do it as two queries
SELECT id INTO @maxid FROM notes ORDER BY id DESC LIMIT 1;
UPDATE notes SET originalid = @maxid where id = @maxid;

or
SELECT MAX(id) INTO @maxid FROM notes;
UPDATE notes SET originalid = @maxid where id = @maxid;