DESTINE: Dynamic Goal Queries with Temporal Transductive Alignment for Trajectory Prediction