The distribution of the interstellar medium in the Scd galaxy NGC 6946. II: The CO data