Former Police Scotland officer Derek McNee has been sentenced to seven years in custody after admitting repeated sexual assaults on an unconscious or heavily intoxicated woman.