Chemical implications of variational second-order density matrix theory: study of diatomic molecules along the potential energy curve