La clausola WHERE va prima del GROUP BY

prova così:

SELECT id_formato,id_ordine,SUM(n_copie) AS somma FROM ordini_formati WHERE id_ordine=10 GROUP BY id_formato