I Agree with Manas. There is no meaning of using Order By for insert. but, if you want to select data from onother table then here is the code-
INSERT INTO table
SELECT *
FROM (SELECT col1, col2, col3 FROM table1
UNION ALL
SELECT col1, col2, col3 FROM table2) AS my_union
ORDER BY col1, col2, col3