I don't think it matters if you increase the ppi after the fact.
I create my images in Gimp with a ppi of 600, not changing it after the fact. Your right, after that fact resolution change would probably pixelate the image. Starting it out with a higher ppi seem to make the finished product much nicer.