Yes, it was designed for match shooting out to 1000M (1094 Yards) with a 9.0g (139 gr) bullet
Quite wrong. It was Lapua's answer to the 6mm BR Norma as a 300-metre precision cartridge for ISSF, the very demanding three-position match discipline that is very big commercially and in publicity value in the Nordic countries and northern Europe. It totally bombed in this role, but luckily turned out to be a very flexible number capable of excellent mid and long-range shooting.
Is the 6.5 x 47 a real 1000 yard cartridge?
Yes, easily. It is no longer competitive though in many competition disciplines such as F-Class being out-gunned by larger 6.5 and 7mm cartridges with superior ballistics. I shot F-Class up to 1,000 yards with it around 10 years ago. The 123gn Lapua Scenar at just under 3,000 fps (30-inch barrel) gave me some great results in 800 yard stages, but was left behind in 900 and 1,000 yard stages by the bigger sevens, ie 284 Win and 7WSM.
Re powders, as several people have said in their posts, there seems to be a divide between individual rifles/barrels, the cartridge sitting on a watershed. Most perform much better with VarGet / Re15; somewhat fewer with H4350; very few seem to like both powder classes. Mine shot very well with Viht N150 and the 123s. As with many UK 6.5X47Ls of that period, the chamber was throated too short to allow CIP 2.8" OALs and optimum performance from the longer 140gn bullets. (Those people I know who've tried both forms ended up preferring the shorter version / shorter bullets and have settled on that, but one-time US 6.5X47L long-range king Erik Cortina was an advocate of heavier bullets and did very well indeed at long ranges with this combination.) Personally, I'd regard N140 as a tad too fast-burning for the cartridge even with 123s, but precision may be good even if it loses a bit of MV.
However, the important thing is to be very careful not to overload this very small case design in the pursuit of velocity - it simply doesn't exhibit over-pressure symptoms until ejector extrusion signs appear. Primers just don't flatten in it until really serious over-pressures are reached, and may not do so even then. With hindsight, I realise I pushed the cartridge too hard to make it competitive at 1,000. Unlike many designs, it still shoots superbly when running really 'hot', and its cases are so strong, the usual over-pressure giveaway of short case life and slack primer pockets doesn't show. In my rifle's case, the give-way was much shorter barrel life than should have been available from this case-capacity class of 6.5. I have a Northern England gunsmith friend who mostly builds 'tactical' rifles and precision heavy sporters and who has built many, many 6.5X47Ls for people as well as being a one-time user himself. He tells me some of the remaining 6.5X47 Tactical / PRS / McQueens competitors are among his best rebarrelling service customers.