Final Destiny is a Normal Spell Card.
Spell Cards are usually activated from the hand on your turn unless their type gives another timing window.
On the current TCG and OCG Forbidden & Limited lists tracked here, Final Destiny is Unlimited.
YGOPRODeck lists Final Destiny for these formats: GOAT, OCG GOAT, Duel Links, Common Charity, Edison, TCG, OCG, Master Duel.
A listed print of Final Destiny appears in Dark Beginning 1 (DB1-EN020) at Common rarity.
Among markets shown on this page, the lowest listed snapshot for Final Destiny is about $0.05 on Cardmarket (prices change frequently).
