Can I apply for a Spanish transit visa without holding a visa for the final destination?

No. Proof of legal entry (entry visa, residence card, or official exemption document) for the ultimate destination is an indispensable prerequisite.