Gunmen have killed at least six people when they opened fire on the congregation during a prayer service at a church in Nigeria.