A movie about the power of prayer, made by Christian film-makers with an all-Christian cast, has gone to the top of the North American box office chart.