Any star tip — open or closed— will work depending on how small you want them. 18 or so is a good choice if you have good/hard squeezing/ hand pressure.
look into the PME brand piping tips. They are small, seamless, and wonderful to use. the rose tips were used for these toothpick roses, you could google PME star tips for tiny rosettes.