SELECT 
  YourColumn,
  OtherData
FROM YourTable
WHERE YourColumn = 'Apple'
ORDER BY YourColumn Collate SQL_Latin1_General_CP850_BIN

;With MySampleData AS (
SELECT N,
CHAR(MiniTally.N) + 'pple' As Word
FROM (SELECT 
      ROW_NUMBER() OVER (ORDER BY name) AS N 
      FROM sys.columns)MiniTally
WHERE N BETWEEN 32 AND 255
)
SELECT * 
from MySampleData
ORDER BY Word,Word Collate SQL_Latin1_General_CP850_BIN

DECLARE @Apples TABLE
(
    sequence    integer NOT NULL,
    apple       varchar(6) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL
)

INSERT @Apples
    (sequence, apple)
VALUES
    (1, '!apple'),
    (2, '-apple'),
    (3, '0apple'),
    (4, '1apple'),
    (5, 'APPLE'),
    (6, 'Apple'),
    (7, 'apple'),
    (8, 'àpple'),
    (9, 'Bpple'),
    (10, 'bpple'),
    (11, 'èpple'),
    (12, 'Zpple'),
    (13, 'zpple')

SELECT * 
FROM @Apples AS a 
ORDER BY apple;

-- SQL Server Sort Order 54 on Code Page 1252 for non-Unicode Data
SELECT * 
FROM sys.fn_helpcollations() AS fh 
WHERE fh.name = 'SQL_Latin1_General_CP1_CI_AI';