The Eb trumpets are used today especially for concerts of Bach and Hummel, using the original transcription. In former times it has been used also in brass orchestras similar to French horns.
The D trumpet allows much easier interpretation of Baroque music (e.g. Bach or Händel). Sometimes the pieces written for D trumpet are instead interpreted by Piccolo trumpet.