Older people who go to church tend to have better mental health and a bigger social network, it has emerged.