Two children, aged eight and 10, have been killed and 17 other people injured following a shooting during Mass.