Insert into tabela (campo) values (select max(campo)+1 from tabela)

Qual o problema com essa SQL?

INSERT INTO tabela (Ordem) VALUES ((SELECT MAX(Ordem) as Od FROM materia))

dá esse erro:

You can't specify target table 'materia' for update in FROM clause

Vlw galera