You seem to have misunderstood Twinned Spell slightly.
It doesn't cause a second instance of the spell to target another viable creature within range; it causes the same instance of the spell to target two viable creatures within range instead of just one. The relevant section of Twinned Spell reads as follows (emphasis mine):
... you can spend a number of sorcery points equal to the spell's level to target a second creature in range with the same spell.
This has a couple of implications.
First off, for spells like Polymorph, both of the creatures you're targeting turn into the same creature. However, you can keep concentration on both creatures, as it is only one instance of the spell, as opposed to two.
Secondly, for spells with a damage roll (like Chromatic Orb), you roll the attack roll separately for each creature, but you only roll damage once.
For spells that require concentration, both creatures are affected by the concentration effect. For example, if you cast Twinned Witch Bolt, if you hit both targets, you deal 1d12 lightning damage to them on the first turn, and you can use your action to deal 1d12 additional damage on each of your turns to each of the targets. If you fail a concentration check, you lose concentration on the spell for both creatures, not just one of them. Whether moving outside the range of Witch Bolt ends the spell for one or both creatures is up for interpretation by your DM (a strict reading of the RAW would suggest it ends for both of them, but I would personally rule that it only ends for the creature moving out of range).
In short, your polymorph spell turns the two targets into the same kind of creature.
Spell Scrolls1
Provided you obtain enough of them and have enough time to cast them all, using 9th level spell scrolls would allow one to cast a lot of 9th level spells without a long rest.
Epic Boons
The DMG has rules for granting epic boons (starting on page 231) that include:
Boon of High Magic
You gain one 9th-level spell slot, provided that you already have one.
Boon of spell recall
You can cast any spell you know or have prepared without expending a spell slot. Once you do so, you can't use this boon again until you finish a long rest.
Either of these boons would allow one to cast Foresight (or another 9th level spell) twice before taking a long rest.
Monsters
Monsters do not have the same restrictions as player characters and it is also possible for them to have more than one 9th level spell slot. An example of this in published adventures is (spoilers):
Acererak from Tomb of Anihilation
1. Suggested by NautArch
Best Answer
Yes
The main question is: how reliable do you want it to be?
The unreliable option
A 9th-level sorcerer has enough sorcery points to twin a spell scroll of foresight; however, spell scrolls have the following restriction:
Therefore, the lowest level option is Sorcerer 9 / [Bard, Druid, Warlock, or Wizard] 1. Unfortunately, a 1st-level bard, druid, warlock, or wizard can only cast 1st-level spells normally, so the following restriction applies when using the scroll:
If the sorcerer has 20 Charisma (and chose bard or warlock as their single additional level), they only have a 30% chance of successfully casting the spell.
The reliable option
We need 9 levels of sorcerer to be able to twin foresight, as well as 17 levels of bard, druid, warlock, or wizard to avoid the spell scroll ability check. Since that is impossible, we need another option. The 8th-level spell glibness holds the key:
The spellcasting ability check will be Charisma-based, if we choose a level of bard or warlock. With glibness and at least 18 Charisma, the spell scroll ability check cannot be failed (15 + 4 = 19).
But wait! Glibness isn't a sorcerer spell. Fortunately, we can use wish to duplicate glibness. Putting all of that together, we'll need Sorcerer 17 / [Bard or Warlock] 1.
The mount option
The spell find steed has an interesting clause that gives us another option (which works for find greater steed, as well):
Therefore, if you cast foresight while mounted, your steed also receives the benefits of the spell. Find steed and find greater steed are paladin-only, but a bard can use Magical Secrets to grab one of them. Bard 17 can get you foresight and find greater steed without much fuss. Wizard 17 could use wish to duplicate find greater steed, take a long rest, and then use foresight while mounted for the same effect.
The "cheating" option
This isn't technically what you asked for, but I'm including it for the sake of completeness. Wizard 17 could use simulacrum to create a copy of themselves, then the wizard and their sim could both cast foresight. Bard 17 could do the same, if they took simulacrum with their Magical Secrets.