The final edition of the News of the World saw its circulation soar by more than a million copies, new figures show.