An intense manhunt is under way for a young white man who joined a prayer meeting and then opened fire inside a church, killing nine people.