t_item:

CREATE TABLE t_item_new LIKE t_item;
INSERT INTO t_item_new
SELECT * FROM t_item
ORDER BY a_index;
ALTER TABLE t_item RENAME t_item_old;
ALTER TABLE t_item_new RENAME t_item;

t_npc:

CREATE TABLE t_npc_new LIKE t_npc;
INSERT INTO t_npc_new
SELECT * FROM t_npc
ORDER BY a_index;
ALTER TABLE t_npc RENAME t_npc_old;
ALTER TABLE t_npc_new RENAME t_npc;

t_npc_regen:

CREATE TABLE t_npc_regen_new LIKE t_npc_regen;
INSERT INTO t_npc_regen_new
SELECT * FROM t_npc_regen
ORDER BY a_zone_num;
ALTER TABLE t_npc_regen RENAME t_npc_regen_old;
ALTER TABLE t_npc_regen_new RENAME t_npc_regen;