That depends on your overall design scheme- some people choose a neutral color like ecru, some prefer the door to be a dynamic focal point- cape cod blue, harvest orange.
Go to home Depot and look at their selection of paints and choose the one that is most flattering. You will need a specific type of paint to paint the door. but usually, the color of the door should complement the walls. White and brown is the standard choice.