An incredibly rare comic book, described by collectors as the "holy grail," has sold for $956,000 at an auction in Dallas.