CREATE TRIGGER ids_nomatch
BEFORE INSERT ON student FOR EACH ROW
SELECT student.identifier, teacher.identifier,
    CASE WHEN student.identifier NOT IN (SELECT teacher.identifier FROM teacher) THEN  INSERT   student.identifier SET student.identifier = MAX(student.identifier JOIN teacher.identifier) +1 FROM student, teacher