> In the case of a military officer who is also a knight, the appropriate form of address puts the professional military rank first, then the correct manner of address for the individual, then his name

According to the wikipedia page. Professor has precendence over Sir, but Dr. does not and is thus overriden.