A deadly stampede during a palliative distribution at a church in Nigeria's capital has left at least 10 people dead.