must be a rank below general de brigade (chef de bataillon - colonel), ideally major or colonel (as you get promoted to colonel or general de brigade for a good job) if you want a high chance to get involved in the 1812 russian campaign afterwards
i think if youre a chef de bataillon then you get sent to spain after your diplomat mission regardless (even if you got promoted to major)