With many of younger generation found to identify as ‘spiritual’, research counters assumption spirituality is on decline and in fact implies God is ‘making a comeback’