Fixation probabilities in populations under demographic fluctuations