Does this sql rewrite preserve sort order in mysql

In the book High performance mysql 3rd edition, it says

>A frequent problem is having a high value for the offset. If your query looks like LIMIT
10000, 20, it is generating 10,020 rows and throwing away the first 10,000 of them,
which is very expensive.
>
>One simple technique to improve efficiency is to do the offset on a covering index,
rather than the full rows.
>
>Consider the following
query:
>
>SELECT film_id, description FROM sakila.film ORDER BY title LIMIT 50, 5;
>
>If the table is very large, this query is better written as follows:
>
>mysql> SELECT film.film_id, film.description
> -> FROM sakila.film
> -> INNER JOIN (
> -> SELECT film_id FROM sakila.film
> -> ORDER BY title LIMIT 50, 5
> -> ) AS lim USING(film_id);
>
>This “deferred join” works because it lets the server examine as little data as possible
in an index without accessing rows, and then, once the desired rows are found, join
them against the full table to retrieve the other columns from the row.

My question is, does the second SQL preserve the same result set order as the first SQL, since it has no order by clause outside?

Here is the table DDL for quick reference:

CREATE TABLE film (
  film_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  title VARCHAR(128) NOT NULL,
  description TEXT DEFAULT NULL,
  release_year YEAR DEFAULT NULL,
  language_id TINYINT UNSIGNED NOT NULL,
  original_language_id TINYINT UNSIGNED DEFAULT NULL,
  rental_duration TINYINT UNSIGNED NOT NULL DEFAULT 3,
  rental_rate DECIMAL(4,2) NOT NULL DEFAULT 4.99,
  length SMALLINT UNSIGNED DEFAULT NULL,
  replacement_cost DECIMAL(5,2) NOT NULL DEFAULT 19.99,
  rating ENUM('G','PG','PG-13','R','NC-17') DEFAULT 'G',
  special_features SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes') DEFAULT NULL,
  last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY  (film_id),
  KEY idx_title (title),
  KEY idx_fk_language_id (language_id),
  KEY idx_fk_original_language_id (original_language_id),
  CONSTRAINT fk_film_language FOREIGN KEY (language_id) REFERENCES language (language_id) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT fk_film_language_original FOREIGN KEY (original_language_id) REFERENCES language (language_id) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

In my experience the result will preserve the ordering of the subquery, but I'm not sure it's guaranteed. So you should repeat the ORDER BY clause.

SELECT film.film_id, film.description
FROM sakila.film
INNER JOIN (
    SELECT film_id 
    FROM sakila.film
    ORDER BY title 
    LIMIT 50, 5
) AS lim USING(film_id)
ORDER BY title