create table items
(
  itemid int primary key,
  itemdata varchar(200),
  ...
  ...
  userorder ???
);

select * from items order by userorder asc;